ALTER TABLE [Gallery.Images] ADD [Type] NVARCHAR(50) NULL

UPDATE [Gallery.Images] SET [Type] = 'Url'

ALTER TABLE [Gallery.Images] ALTER COLUMN [Type] NVARCHAR(50) NOT NULL